package com.flash.TAManagement.mapper;


import com.flash.TAManagement.entity.TaDealingBalance;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TaDealingBalanceMapper {
    @Select("select d.fundId as fundId,t.TAId as TAId,d.cashId as cashId,d.dealPrice as dealPrice,d.dealNumber as dealNumber," +
            "d.dealMoney as dealMoney,d.dealTime as dealTime,d.dealWay as dealWay,d.dealState as dealState from \n" +
            "dealData d join Ta t on d.cashId=t.cashId where 1=1")
    List<TaDealingBalance> selectTaDealingBalance();
//    @Select("select count(*) from(select d.fundId,t.TAId,d.cashId,d.dealPrice,d.dealNumber,d.dealMoney,d.dealTime,d.dealWay,d.dealState from \n" +
//            "dealData d join Ta t on d.cashId=t.cashId)where 1=1")
//    int selectTaDealingBalanceCount();
}
